How to: Set subform/subreport defaults in reports.
Solution:
In Report Design view, select the 'View' menu and select 'Properties'. Click 'Subform/Subreport'. Set the desired defaults.
NOTE: Using this procedure will only affect new controls on the current report.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the database window.
Reports tab
3) Select the desired report. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Properties'. (The property sheet appears.)
6) Click 'Subform/Subreport' in the toolbox. (The Default Subform/Subreport dialog box appears.)
7) Click the 'Format' tab from the Default Subform/Subreport dialog box.
8) Click on the 'Visible' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to determine whether to have the label visible:
1] Select 'Yes' from the 'Visible' drop-down list to have the label visible on the form.
2] Select 'No' from the 'Visible' drop-down list for the label not to be visible on the form.
9) Click on the 'Can Grow' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to determine whether to automatically adjust vertically a control to print or display:
1] Select 'Yes' from the 'Can Grow' drop-down list to have the control automatically adjust vertically to print or display on the form.
2] Select 'No' from the 'Can Grow' drop-down list to not have the control automatically adjust vertically to print or display on the form.
10) Click on the 'Can Shrink' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to determine whether to automatically shrink the control:
1] Select 'Yes' from the 'Can Shrink' drop-down list to automatically shrink the control vertically so that there are no blank lines when printing the data.
2] Select 'No' from the 'Can Shrink' drop-down list to not have the control shrink.
11) Type the desired width of the label in the 'Width' box.
12) Type the desired height of the label in the 'Height' box.
13) Click on the 'Special Effect' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Select the desired effect for the label from the 'Special Effect' drop-down list.
14) Click on the 'Border Style' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Select the desired border style for the label from the 'Border Style' drop-down list.
15) Click on the 'Border Width' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Select the desired width for the label border from the 'Border Width' drop-down list.
16) Click on the 'Border Color' box. (A Build button appears.)
a) Click 'Build'. (The Color dialog box appears.)
b) Select the desired color.
c) Click 'OK'. (The Default Subform/Subreport dialog box reappears.)
17) Click on the 'Auto Label' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to determine whether a label automatically appears with a control:
1] Select 'Yes' from the 'Auto Label' drop-down list to automatically have the label inserted on the report.
2] Select 'No' from the 'Auto Label' drop-down list for the label not be to automatically be inserted on the report.
18) Click on the 'Add Colon' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to determine whether a colon follows the text in a label:
1] Select 'Yes' from the 'Add Colon' drop-down list to have a colon follow the text in labels.
2] Select 'No' from the 'Add Colon' drop-down list to not have a colon follow the text in labels.
19) Type the dimension for the horizontal axis for the label text from the upper-left corner of the label's attached control in the 'Label X' box.
20) Type the dimension for the vertical axis for the label text from the upper-left corner of the label's attached control in the 'Label Y' box.
21) Click the 'Label Align' box. (A down arrow appears.)
a) Click the down arrow. (A drop-down list appears.)
b) Do one of the following to determine the distance between the label and the control's upper-left corner:
1] Select 'General' from the 'Label Align' drop-down list to use a general alignment.
2] Select 'Left' from the 'Label Align' drop-down list to align the distance between the control's upper-left corner and the left edge of the label.
3] Select 'Right' from the 'Label Align' drop-down list to align the distance between the control's upper-left corner and the right edge of the label.
4] Select 'Center' from the 'Label Align' drop-down list to align the distance between the control's upper-left corner and the center of the label.
22) Select the 'File' menu and select 'Save' to save changes to the report.
